Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# ALL_MVIEW_DETAIL_RELATIONS

`ALL_MVIEW_DETAIL_RELATIONS` describes the named detail relations that are either specified in the `FROM` list of the subquery that defines a materialized view accessible to the current user, or that are indirectly referenced through views in that `FROM` list. Inline views in the materialized view definition are not represented in this view or the related views.

Related Views

- `DBA_MVIEW_DETAIL_RELATIONS` describes all such detail relations defined for all materialized views in the database.

- `USER_MVIEW_DETAIL_RELATIONS` describes such detail relations defined for all materialized views owned by the current user.

All three views exclude materialized views that reference remote tables or that includes references to a nonstatic value such as `SYSDATE` or `USER`. These views also exclude materialized views that were created as snapshots prior to Oracle8i and that were never altered to enable query rewrite.

Column | Datatype | NULL | Description
--- | --- | --- | ---
`OWNER` | `VARCHAR2(30)` | `NOT NULL` | Owner of the materialized view
`MVIEW_NAME` | `VARCHAR2(30)` | `NOT NULL` | Name of the materialized view
`DETAILOBJ_OWNER` | `VARCHAR2(30)` | `NOT NULL` | Detail object owner
`DETAILOBJ_NAME` | `VARCHAR2(30)` | `NOT NULL` | Detail object name (that is, the name of a table or view)
`DETAILOBJ_TYPE` | `VARCHAR2(9)` |  | `TABLE`, `VIEW`, `SNAPSHOT`, `CONTAINER`, or `UNDEFINED`
`DETAILOBJ_ALIAS` | `VARCHAR2(30)` |  | Implicit or explicit alias for detail relation